package com.soft.mapper;

import java.util.List;
import java.util.Map;

public interface StudentAnyMapper {

    public List<Map<String, Object>> listClassesInfo();

    public Map<String, Double> findClassesCoreTaskCompleteRate();

    public Map<String, Double> findClassesCoreSubmitRate();

    public Map<String, Double> findClassesCoreTaskCompleteRateLt40();

    public Map<String, Double> findClassesCoreTaskCompleteRateGt80();

    public List<Map<String, Object>> listClassesCoreTaskCompleteRateLt40();

    public List<Map<String, Double>> listAllClassTotalAndAvgScore();

    public List<Map<String, Object>> listEveryClassAvgScore();
    //查询学生等级人数
    public Map<String,Integer> listStudentLevelCount();

    public List<Map<String, Object>> listEveryClassesCoreTaskCompleteRateAndCoreSubmitRate();

}
